﻿<%@ Page Title="" Language="VB" MasterPageFile="~/Library/Reportes.master" AutoEventWireup="false"
    CodeFile="RPTHogaresPersonasXQuinquenio1.aspx.vb" Inherits="Reportes_RPTHogaresPersonasXQuinquenio1" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server">
    <style type="text/css">
        .AlineacionDerecha
        {
            text-align: right;
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="Server">
    <h1>
        Total de personas por quinquenio</h1>
    
    <table>
        <tr>
            <th colspan="2">
                Opciones de filtro
            </th>
        </tr>
        <tr>
            <td>
                Proyecto
            </td>
            <td>
                <asp:DropDownList ID="ddlProyectos" runat="server">
                </asp:DropDownList>
            </td>
        </tr>
        <tr>
            <td>
                Municipio
            </td>
            <td>
                <asp:DropDownList ID="ddlMunicipio" runat="server">
                </asp:DropDownList>
            </td>
        </tr>
        <tr>
            <td>
                Visita
            </td>
            <td>
                <asp:DropDownList ID="ddlVisita" runat="server">
                </asp:DropDownList>
            </td>
        </tr>
        <%--<tr>
            <td>
                Variable
            </td>
            <td>
                <asp:DropDownList ID="ddlVariable" runat="server">
                </asp:DropDownList>
            </td>
        </tr>--%>
        <tr>
            <td>
                Ordenar datos por:
            </td>
            <td>
                <asp:DropDownList ID="ddlOrden" runat="server">
                    <asp:ListItem Value='2' Selected="True">Detalle</asp:ListItem>
                    <asp:ListItem Value='3'>Columna feminino</asp:ListItem>
                    <asp:ListItem Value='4'>Columna Masculino</asp:ListItem>
                    <asp:ListItem Value='5'>Columna Total</asp:ListItem>
                </asp:DropDownList>
                &nbsp;&nbsp; en orden: &nbsp;
                <asp:DropDownList ID="ddldesAsc" runat="server">
                    <asp:ListItem Value='asc' Selected="True">Ascendente</asp:ListItem>
                    <asp:ListItem Value='desc'>Descendente</asp:ListItem>
                </asp:DropDownList>
            </td>
        </tr>
        <tr>
            <td colspan="2" class="botones">
                <asp:Button ID="btnConsultar" runat="server" Text="Ver reporte" CssClass="boton" />
                <asp:Button ID="btnExp" runat="server" Text="Exportar a excel" CssClass="boton" />
            </td>
        </tr>
    </table>
    <table>
        <tr>
            <td colspan="2">
               Total de personas por quinquenio
            </td>
        </tr>
        <tr>
            <td valign="Top"  colspan="2">
                <asp:GridView ID="grdResultado" runat="server" AutoGenerateColumns="false">
                    <Columns>
                        <asp:BoundField DataField="Detalle" HeaderText="Detalle" />
                        <asp:BoundField DataField="Femenino" HeaderText="Femenino">
                            <ItemStyle HorizontalAlign="Right" CssClass="AlineacionDerecha"></ItemStyle>
                        </asp:BoundField>
                        <asp:BoundField DataField="ParticipacionF" HeaderText="% Femenino" DataFormatString="{0:P2}">
                            <ItemStyle HorizontalAlign="Right" CssClass="AlineacionDerecha"></ItemStyle>
                        </asp:BoundField>
                        <asp:BoundField DataField="Masculino" HeaderText="Masculino">
                            <ItemStyle HorizontalAlign="Right" CssClass="AlineacionDerecha"></ItemStyle>
                        </asp:BoundField>
                        <asp:BoundField DataField="ParticipacionM" HeaderText="% Masculino" DataFormatString="{0:P2}">
                            <ItemStyle HorizontalAlign="Right" CssClass="AlineacionDerecha"></ItemStyle>
                        </asp:BoundField>
                        <asp:BoundField DataField="total" HeaderText="Total">
                            <ItemStyle HorizontalAlign="Right" CssClass="AlineacionDerecha"></ItemStyle>
                        </asp:BoundField>
                        <asp:BoundField DataField="Participacion" HeaderText="Participación del total" DataFormatString="{0:P2}">
                            <ItemStyle HorizontalAlign="Right" CssClass="AlineacionDerecha"></ItemStyle>
                        </asp:BoundField>
                    </Columns>
                </asp:GridView>
            </td>
        </tr>
        <tr>
            <td valign="Top" colspan="2">
                <asp:Chart ID="Chart1" runat="server" Palette="BrightPastel" BackColor="#F3DFC1"
                    Width="412px" Height="296px" BorderlineDashStyle="Solid" BackGradientStyle="TopBottom"
                    BorderWidth="2" BorderColor="181, 64, 1">
                    <Titles>
                        <asp:Title ShadowColor="32, 0, 0, 0" Font="Trebuchet MS, 12.25pt, style=Bold" ShadowOffset="3"
                            Name="Title1" ForeColor="26, 59, 105">
                        </asp:Title>
                    </Titles>
                    <Legends>
                        <asp:Legend TitleFont="Microsoft Sans Serif, 8pt, style=Bold" BackColor="Transparent"
                            Font="Trebuchet MS, 8.25pt, style=Bold" IsTextAutoFit="False" Enabled="False"
                            Name="Default">
                        </asp:Legend>
                    </Legends>
                    <BorderSkin SkinStyle="Emboss"></BorderSkin>
                    <Series>
                        <asp:Series Name="Default">
                        </asp:Series>
                    </Series>
                    <ChartAreas>
                        <asp:ChartArea Name="ChartArea1" BorderColor="64, 64, 64, 64" BackSecondaryColor="White"
                            BackColor="OldLace" ShadowColor="Transparent" BackGradientStyle="TopBottom">
                            <Area3DStyle Rotation="10" Perspective="10" Inclination="15" IsRightAngleAxes="False"
                                WallWidth="0" IsClustered="False" />
                            <AxisY LineColor="64, 64, 64, 64" LabelAutoFitMaxFontSize="8">
                                <LabelStyle Font="Trebuchet MS, 8.25pt, style=Bold" Format="C0" />
                                <MajorGrid LineColor="64, 64, 64, 64" />
                            </AxisY>
                            <AxisX LineColor="64, 64, 64, 64" LabelAutoFitMaxFontSize="8">
                                <LabelStyle Font="Trebuchet MS, 8.25pt, style=Bold" IsEndLabelVisible="False" Format="MM-dd" />
                                <MajorGrid LineColor="64, 64, 64, 64" />
                            </AxisX>
                        </asp:ChartArea>
                    </ChartAreas>
                </asp:Chart>
                <asp:RadioButtonList runat = "Server" ID="rbTipoGrafica1" AutoPostBack="True" RepeatDirection=Horizontal >
                    <asp:ListItem Text="Columnas" Value="10" Selected="True"  />
                    <asp:ListItem Text="Barras" Value="7"/>
                    <asp:ListItem Text="Circular" Value="17"/>
                    <asp:ListItem Text="Linea" Value="3"/>                
                </asp:RadioButtonList>
            </td>
        </tr>
        <tr>
            <td valign="Top">
                <asp:Chart ID="Chart2" runat="server" Palette="BrightPastel" BackColor="#F3DFC1"
                    Width="412px" Height="296px" BorderlineDashStyle="Solid" BackGradientStyle="TopBottom"
                    BorderWidth="2" BorderColor="181, 64, 1">
                    <Titles>
                        <asp:Title ShadowColor="32, 0, 0, 0" Font="Trebuchet MS, 12.25pt, style=Bold" ShadowOffset="3"
                            Name="Title1" ForeColor="26, 59, 105">
                        </asp:Title>
                    </Titles>
                    <Legends>
                        <asp:Legend TitleFont="Microsoft Sans Serif, 8pt, style=Bold" BackColor="Transparent"
                            Font="Trebuchet MS, 8.25pt, style=Bold" IsTextAutoFit="False" Enabled="False"
                            Name="Default">
                        </asp:Legend>
                    </Legends>
                    <BorderSkin SkinStyle="Emboss"></BorderSkin>
                    <Series>
                        <asp:Series Name="Default">
                        </asp:Series>
                        <asp:Series Name="Default2"></asp:Series>
                    </Series>
                    <ChartAreas>
                        <asp:ChartArea Name="ChartArea1" BorderColor="64, 64, 64, 64" BackSecondaryColor="White"
                            BackColor="OldLace" ShadowColor="Transparent" BackGradientStyle="TopBottom">
                            <Area3DStyle Rotation="10" Perspective="10" Inclination="15" IsRightAngleAxes="False"
                                WallWidth="0" IsClustered="False" />
                            <AxisY LineColor="64, 64, 64, 64" LabelAutoFitMaxFontSize="8">
                                <LabelStyle Font="Trebuchet MS, 8.25pt, style=Bold" Format="C0" />
                                <MajorGrid LineColor="64, 64, 64, 64" />
                            </AxisY>
                            <AxisX LineColor="64, 64, 64, 64" LabelAutoFitMaxFontSize="8">
                                <LabelStyle Font="Trebuchet MS, 8.25pt, style=Bold" IsEndLabelVisible="False" Format="MM-dd" />
                                <MajorGrid LineColor="64, 64, 64, 64" />
                            </AxisX>
                        </asp:ChartArea>
                    </ChartAreas>
                </asp:Chart>
                <asp:RadioButtonList runat = "Server" ID="rbTipoGrafica2" AutoPostBack="True" RepeatDirection=Horizontal >
                    <asp:ListItem Text="Columnas" Value="10" Selected="True"  />
                    <asp:ListItem Text="Barras" Value="7"/>
                    <asp:ListItem Text="Linea" Value="3"/>                
                </asp:RadioButtonList>
            </td>
        </tr>
    
    
    <tr>
        <td>
        <h2>Pirámide poblacional</h2>

        <asp:Chart ID="Chart4" runat="server" Palette="BrightPastel" BackColor="#F3DFC1"
                    Width="600px" Height="600px" BorderlineDashStyle="Solid" BackGradientStyle="TopBottom"
                    BorderWidth="2" BorderColor="181, 64, 1">
                    <Titles>
                        <asp:Title ShadowColor="32, 0, 0, 0" Font="Trebuchet MS, 12.25pt, style=Bold" ShadowOffset="3"
                            Name="Title1" ForeColor="26, 59, 105" Text = "Pirámide poblacional" >
                        </asp:Title>
                    </Titles>
                    <Legends>
                        <asp:Legend TitleFont="Microsoft Sans Serif, 8pt, style=Bold" BackColor="Transparent"
                            Font="Trebuchet MS, 8.25pt, style=Bold" IsTextAutoFit="true" Enabled="true"
                            Name="Default">
                        </asp:Legend>
                    </Legends>
                    <BorderSkin SkinStyle="Emboss"></BorderSkin>
                    <Series>
                        <asp:Series Name="Default">
                        </asp:Series>
                        <asp:Series Name="Default2"></asp:Series>
                    </Series>
                    <ChartAreas>
                        <asp:ChartArea Name="ChartArea1" BorderColor="64, 64, 64, 64" BackSecondaryColor="White"
                            BackColor="OldLace" ShadowColor="Transparent" BackGradientStyle="TopBottom">
                            <Area3DStyle Rotation="10" Perspective="10" Inclination="15" IsRightAngleAxes="False"
                                WallWidth="0" IsClustered="False" />
                            <AxisY LineColor="64, 64, 64, 64" LabelAutoFitMaxFontSize="8">
                                <LabelStyle Font="Trebuchet MS, 8.25pt, style=Bold" Format="C0" />
                                <MajorGrid LineColor="64, 64, 64, 64" />
                            </AxisY>
                            <AxisX LineColor="64, 64, 64, 64" LabelAutoFitMaxFontSize="8">
                                <LabelStyle Font="Trebuchet MS, 8.25pt, style=Bold" IsEndLabelVisible="False" Format="MM-dd" />
                                <MajorGrid LineColor="64, 64, 64, 64" />
                            </AxisX>
                        </asp:ChartArea>
                    </ChartAreas>
                </asp:Chart>



            <asp:LinkButton ID="LinkButton1" runat="server" Visible = "false"  >Exportar anexo a excel</asp:LinkButton>
            <asp:GridView ID="GridView3" runat="server" AutoGenerateColumns="true" Visible = "false" >
            </asp:GridView>
        
        </td>
        </tr>
    
    </table>


</asp:Content>
